Computer science Lesson Plan
Class: 5 - Lesson:5 Basics of Spreadsheet .

Purpose: Learn about row, column,cell and cell address,insert / delete a row,a column & a new sheet,rename a sheet.

No. of Classes

One or two classes (Teacher's decision).

Material Required

Open office(Spreadsheet).

Curriculum Content
  • 4) Other applications of computers.
    •

    Prior knowledge

    Students should know open office textdocument and basics of presentation clearly.

    Exercises

    Exercise:1


    What do you mean by spreadsheet? Explain the uses of spreadsheets.

    Exercise:2


    2.Insert a new sheet and delete sheet -2 in the spreadsheet and rename the sheet-3.

    Solution


  • Link to view the solutions for exercise-1.

    • Teacher's Instruction
    1. Teachers should ensure that Students practice all the feature
    2. Explain the row number and column name in Spreadsheet
    3. Differentiate spreadsheets and text documents.
    4. Explain about autofill feature and its usage in filling dates, days & S. No.
    5. Make them to understand inserting / moving / renaming a new sheet.
    6. While teaching use the words like row, column, cells, sheet etc. They need to be familiar with those words .